package com.ly.cloud.mapper;


import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.baomidou.mybatisplus.plugins.pagination.Pagination;
import com.ly.cloud.dto.GradeProfessionalInfoDto;
import com.ly.cloud.entity.GradeProfessionalInfoPo;
import com.ly.cloud.vo.*;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;
/**
* @Description:
* @Author: pengshiqing
* @CreateDate: 2018/12/19
*/
@Mapper
public interface GradeProfessionalInfoMapper extends BaseMapper<GradeProfessionalInfoPo> {

    //分页+条件查询
    List<GradeProfessionalInfoVo> selectPage(@Param("page") Pagination page , @Param("dto") GradeProfessionalInfoDto dto);

    //查询所有的年级
    List<String> findAllGrade();

    //根据年级查询所有的学院
    List<DwSelectVO> findAllCollegeByGrade(@Param("grade") String grade);

    //查询所有校区
    List<CampusSelectVo> findAllCampus();


    //根据年级查询年级专业，下拉列表
    List<NjzySelectVo> selectNjZyByNj(@Param("nj") String nj);

    //根据年级、学院查询年级专业
    List<NjzySelectVo> findNjzyByNjAndXy(@Param("nj")String nj, @Param("xy")String xy);



}